package com.simen.kv;

/**
 * Created by zhangming on 2017/4/12.
 */
interface Constants {
    String DBNAME = "DBNAME";
    /**
     * 创建字符串型表的SQL语句
     */
    String CREATETEXTKEY = "create table if not exists DBNAME (" + Columns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT,key TEXT,value TEXT,createtime" + " TEXT,updatetime TEXT);";

    /**
     * 创建整型表的SQL语句
     */
    String CREATEINTEGERKEY = "create table if not exists DBNAME (" + Columns._ID + " INTEGER PRIMARY KEY " +
            "AUTOINCREMENT,key TEXT,value TEXT,createtime" + " TEXT,updatetime TEXT);";

    /**
     * 创建二进制表的SQL语句
     */
    String CREATEBLOBKEY = "create table if not exists DBNAME (" + Columns._ID + " INTEGER PRIMARY KEY " +
            "AUTOINCREMENT,key TEXT,value BLOB,createtime" + " TEXT,updatetime TEXT);";

}
